# Amazon S3 target data types

The following table shows the default mapping from Qlik Replicate data types to Amazon S3 target data types. Note that the data type mapping is only relevant if the [Create metadata files in the target folder](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/Amazon%20S3/set_up_file_as_target_in_tasks3.htm#Create) option is enabled.

For information on source data type mappings, see the section for the source endpoint you are using.

For additional information about Qlik Replicate data types, see [Replicate data types](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/Endpoints/att_rep_data_types.htm).

Data types

| Qlik Replicate Data Types | Amazon S3 Target Data Types |
| --- | --- |
| DATE | DATE |
| TIME | TIME |
| DATETIME | DATETIME |
| BYTES | BYTES (length) |
| BLOB | BLOB |
| REAL4 | REAL4 (7) |
| REAL8 | REAL8 (14) |
| INT1 | INT1 (3) |
| INT2 | INT2 (5) |
| INT4 | INT4 (10) |
| INT8 | INT8 (19) |
| UINT1 | UINT1 (3) |
| UINT2 | UINT2 (5) |
| UINT4 | UINT4 (10) |
| UINT8 | UINT8 (20) |
| NUMERIC | NUMERIC (p,s) |
| STRING | STRING (Length) |
| WSTRING | STRING (Length) |
| CLOB | CLOB |
| NCLOB | NCLOB |
| BOOLEAN | BOOLEAN (1) |

## Mapping from Qlik Replicate data types to Parquet

When Parquet is set as the message format, due to the limited number of data types supported by Parquet, the data type mappings will be as shown in the table below.

Parquet data type mappings

| Replicate Data Type | Parquet Primitive Type | Logical Type |
| --- | --- | --- |
| BOOLEAN | BOOLEAN |  |
| INT1 | INT32 | INT(8,<br>true) |
| INT2 | INT32 | INT(16,<br>true) |
| INT4 | INT32 |  |
| INT8 | INT64 |  |
| UINT1 | INT32 | INT(8,<br>false) |
| UINT2 | INT32 | INT(16,<br>false) |
| UINT4 | INT64 |  |
| UINT8 | INT64 | INT(64,<br>false) |
| REAL4 | FLOAT |  |
| REAL8 | DOUBLE |  |
| NUMERIC | FIXED\_LEN\_BYTE\_ARRAY (16) | DECIMAL<br>(precision, scale) |
| STRING | BYTE\_ARRAY | STRING |
| WSTRING | BYTE\_ARRAY | STRING |
| BYTES | BYTE\_ARRAY |  |
| BLOB | BYTE\_ARRAY |  |
| CLOB | BYTE\_ARRAY | STRING |
| NCLOB | BYTE\_ARRAY | STRING |
| DATE | INT32 | DATE |
| TIME | INT32 | TIME(UTC=true, unit=MILLIS) |
| DATETIME | INT64 | TIMESTAMP(UTC=true, unit=MICROS) |